Round 1 - Technical Interview

Work and Conceptual Related:

🔹Tell me about yourself, kind of projects and tech stack used.

🔹How does your day to day work look like.

🔹Why are you using the tech stack you are using

🔹What is the alternative to Medallion Architecture

🔹What is the kind and size of data you deal with on daily basis

🔹If the business is using JSON as the file format and you have to convince the business to use Parquet. How are you going to convince the Business?

PySpark Problem:

🔹Given the Dataframe, how are you going to split the data into two columns ('Even', 'Odd'), where are even numbers are populated to Even column and Odd numbers are populated into Odd column.

Python Problem:

🔹Given an array, find the min and max within the array.

SQL Problem:

🔹Given a table with column 'Country', select the data as below sequence.

Table: Matches:

Col: Country

India

Australia

Pakistan

O/P:

India vs Australia

India vs Pakistan

Australia vs Pakistan

🔹Given 2 tables as below. Find the count of records for Left Outer Join and Inner Join respectively:

A:

1

1

1

1

B:

1

1

1

🔹Note the values for DenseRank() and Rank() output for below data:

I/P:

85

85

80

75

75

70

Round 2 - Technical Interview

Work and Conceptual Related:

🔹Tell me about yourself, kind of projects and tech stack used.

🔹Explain the architecture of Spark

🔹Explain the process how jobs run in Spark.

🔹Some follow up questions like what does Catalyst Optimizer do.

🔹What is the difference between Logical Plan and Physical Plan

🔹Difference between ORC and Parquet

PySpark Problem:

🔹Read a CSV file and create a dataframe with properties.

🔹Create a dataframe with two columns with default String and default Integer respectively.

Python Problem:

🔹Given a string, output the count of each word into a dictionary:

I/P: string = 'aaabbbccddeeeee'

O/P: Dict = { “a” : 3 , “b” : 3, “c” : 2, “d” :2 , “e” :5 }

🔹Write a python program to count occurrence of an input string in a file . e.g. find the number of 

occurrences of the word ‘The’ in the sentence ‘The lazy fox jumps over the sleeping rabbit. The lazy 

rabbit doesn’t wake up’. has context menu

SQL Problem:

🔹Given two tables, output the result of Inner, left, right, full Joins respectively.

Table1:

col1

1

1

Table2:

col1

b

a

1

Round 3 - Hiring Manager

Work and Conceptual Related:

🔹Tell me the difference between Datalake and Deltalake

🔹Why did you quit the job?

🔹Even though you have an offer in hand, why did you apply again?

🔹Are you willing to join if we offer same as the offer you have in hand

🔹Are you willing to relocate Bangalore, even though you are settled in Hyderabad. Why?